﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of eComPaymentTerm">
	<Sql>
		SELECT eComPT.id as id, externalProcessing, mustPayAtCheckOut FROM
			eComPaymentTerms as eComPT
		INNER JOIN
			eComProductTermsLink as eComPTL ON eComPTL.paymentTermsId =  eComPT.id
		INNER JOIN
			eComProducts as eComProd on eComProd.id = eComPTL.productId
		WHERE
			eComProd.id = @prodId
	</Sql>
	<Param name="prodId" type="UniqueIdentifier"/>	
</AdoNetDataAccess>